SUPPORT / SAMPLES & SAS NOTES
Problem Note 50221: The field CONTRY_NM in the GEO_UP_DIM table is not populated in SAS® Customer Experience Analytics Server 6.1
 |  |  |  |  |
In SAS Customer Experience Analytics Server 6.1, the COUNTRY_NM field in the GEO_IP_DIM table is not populated with the country name. The field is always empty despite the fact that the source is populated.
As a workaround for this problem, add the following data-cleaning code to the uncompiled macro:
'cxa_clean_geo_ip_dim':
COUNTRY_NM=country_name;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Experience Analytics | 64-bit Enabled AIX | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft® Windows® for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Linux for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Solaris for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||